package org.jeecg.modules.nc.mapper;

import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import org.apache.ibatis.annotations.Param;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.nc.entity.NcPersonnel;
import org.jeecg.modules.nc.vo.NCPersonAndJobVo;
import org.jeecg.modules.nc.vo.NCPersonVO;
import org.jeecg.modules.nc.vo.SysUserPsnVo;


/**
 * @Description: nc_personnel
 * @Author: qixin-boot
 * @Date:   2021-11-30
 * @Version: V1.0
 */
public interface NcPersonnelMapper extends BaseMapper<NcPersonnel> {

     List<NCPersonAndJobVo> queryNCPersonelList();

     List<NcPersonnel> queryPsnByDepId(String departId);

     String queryDeptByPsn(String id);

    NcPersonnel queryByUserid(String userId);

    List<NCPersonVO> queryNcPsnListByPkpsndoc(String pkPsndoc);

    void updateDeptName();

    void updateOrgName();

    List<SysUserPsnVo> selectPsnByPkpsndoc(Map<String,Object> map);

    // 将人员的主职/兼职信息都放在人员信息列表中
    IPage<NCPersonAndJobVo> queryPersonList(Page<NCPersonAndJobVo> page, @Param(Constants.WRAPPER) QueryWrapper<NCPersonAndJobVo> queryWrapper);
}
